maintenance/archives/patch-ss_active_users.sql

   1 -- More statistics, for version 1.14
   2
   3 ALTER TABLE /*$wgDBprefix*/site_stats ADD ss_active_users bigint default '-1';
   4 SELECT @activeusers := COUNT( DISTINCT rc_user_text ) FROM /*$wgDBprefix*/recentchanges
   5 WHERE rc_user != 0 AND rc_bot = 0 AND rc_log_type != 'newusers';
   6 UPDATE /*$wgDBprefix*/site_stats SET ss_active_users=@activeusers;